﻿CREATE TABLE [dbo].[Inquiries] (
    [Id]                                            NVARCHAR (100) NOT NULL,
    [Title]                                         NVARCHAR (MAX) NOT NULL,
    [DateInitiated]                                 DATETIME       NOT NULL,
    [DateCompleted]                                 DATETIME       NULL,
    [Link]                                          NVARCHAR (MAX) NOT NULL,
    [Status]                                        NVARCHAR (MAX) NOT NULL,
    [LastModified]                                  DATETIME       NOT NULL,
    [ParliamentNumber]                              INT            NOT NULL,
    [Chamber]                                       NVARCHAR (MAX) NOT NULL,
    [Committee_Id]                                  NVARCHAR (100) NOT NULL,
    [InquiryGenericSearchResult_Inquiry_Id]         NVARCHAR (100) NOT NULL,
    [Bill_Id]                                       NVARCHAR (100) NULL,
    [SenateEstimatesSearchResultInquiry_Inquiry_Id] NVARCHAR (100) NOT NULL
);





